INSERT INTO [dbo].[DimEmployee]
           ([Name]
           ,[Title]
           ,[HireDate]
           ,[BirthDate]
           ,[LoginID]
           ,[EmailAddress]
           ,[Phone]
           ,[Gender]
           ,[PayFrequency]
           ,[BaseRate])
     VALUES
           ('Samuel'
           ,'CEO'
           ,GetDate()
           ,'1978-12-02'
           ,'samuel'
           ,'samuel@microsoft.com'
           ,'(86) 010-1234567'
           ,'M'
           ,'1'
           ,'20000.00')